<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
  <connectionStrings>
    <add name="GAMongoDBConnectionString" connectionString="mongodb://10.12.7.71:27017" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="DSOMongoDBConnectionString" connectionString="mongodb://admin:G4nd4lf2014@52.208.112.211:27017" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ClientPlatform" connectionString="mongodb://10.12.7.71:27017/ClientPlatform" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="MongoDBConnectionString" connectionString="mongodb://10.12.7.71:27017" xdt:Transform="InsertIfMissing" xdt:Locator="Match(name)" />
    <add name="ClientDWMaster" connectionString="mongodb://10.12.7.71:27017/ClientDWMaster" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ValidationRules" connectionString="mongodb://10.12.7.71:27017/Validation" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="RPHistoricalDataSet" connectionString="mongodb://10.12.7.71:27017/RPHistoricalDataSet" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GovernanceInputFile" connectionString="mongodb://10.12.7.71:27017/GovernanceInputFile" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="RPConnectionString_Temp" connectionString="Data Source=sust-test-app-srv.cloudapp.net,51433;User ID=sql_server_admin;Password=G4nd4lf2014;Initial Catalog=DSRSystem_temp;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="GCCSConnectionString" connectionString="Data Source=news-data-srv.westeurope.cloudapp.azure.com;User ID=sql_server_admin;Password=H0bb1t2014;Initial Catalog=Live_GCCS;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="FocusedRatingsConnectionString" connectionString="Data Source=sust-test-app-srv.cloudapp.net,51433;User ID=sql_server_admin;Password=G4nd4lf2014;Initial Catalog=FocusedRatings_Temp;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ActiveMQ" connectionString="activemq:tcp://activemq.test.sust-aws.local:61616" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="ActiveMQTopic" connectionString="Synchronization.Topic.Test" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
    <add name="CarbonDataConnectionString" connectionString="Data Source=news-test.westeurope.cloudapp.azure.com;User ID=sql_carbon;Password=G4nd4lf_2017!;Initial Catalog=CARBON;Pooling=True;Min Pool Size=10;Connect Timeout=10" providerName="System.Data.SqlClient" xdt:Transform="SetAttributes" xdt:Locator="Match(name)" />
  </connectionStrings>
  <appSettings>
    <add key="Steps" value="SyncCorporateData, SyncHbaseData, SyncReferenceUniverses, UniversesFromCrm, LoadFeatureUniverses, CompanyWeights, SyncEsgData, SyncControversies, SyncGlobalCompact, SyncProductInvolvement, SyncGovernance, SyncGovernanceComputation, SyncRiskRatingsData, SyncRiskRatingsBenchmarks, ESGRatingsDataValidation, CarbonData, PITraditional, PISolutions, ReportDataPreparation, FocusedRatingsComputationOutput2, ControversyAlerts, DataValidation, AssureFeatureUniverses,SyncHistoricalData, SyncSecuritiesLists, ScreeningData, PregenerateScreeningReports, CleanupS3, GeneratePDFReports, ProcessedFiles" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="MaxSyncStepExecutionAttempts" value="5" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="SyncStepRetryInitialInterval" value="10" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="GlobalRetryPolicyNumberOfRetries" value="10" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="PdfGenerationServiceWaitTimeInSeconds" value="60" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="PSR_MainMachine" value="i-09b5a947bc375b0bc" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="RedisServer" value="Test-Redis" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="executehistorical" value="false" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="dsDaysOfPreservation" value="40" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="DumpComputationResults" value="true" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="s3bucket" value="test-globalaccess-europe" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="s3bucketCustom" value="test-globalaccess-europe-custom" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="IsSyncAutomatic" value="True" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseUrl" value="canvastaging.westeurope.cloudapp.azure.com" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseThriftServer" value="canvastaging.westeurope.cloudapp.azure.com" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseTablePrefix" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBasePrefix" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HiveConnectionString" value="DRIVER={Hortonworks Hive ODBC Driver};Host=cddbloadbalancer.westeurope.cloudapp.azure.com;Port=10000;Schema=cddb;HiveServerType=2" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="GeneratePartialControveryReports" value="False" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="InitialRecurringDate" value="03/25/2015 07:00:00" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="RegularRepeatInterval" value="0.06:00:00" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="pdfservurl" value="http://10.12.6.43/pdfgenerationserv/" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="CommandTimeout" value="3600" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="DefaultCloudCluster" value="aws" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="templateImage" value="ami-9e256ee9" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awMachineCountAvailable" value="1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="machineDemand" value="1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="awsMachineTag" value="Testing Platform" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="RedisConnectionString" value="Test-Redis" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="DeploymentLocation" value="TEST" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HostUrl" value="http://+:10280/clientsync" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="clientPlatformUrl" value="http://54.194.240.189:80" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="ComputationServiceAddress" value="http://10.12.7.101:10280/esgcomputingserv/api/v1" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="GovernanceServiceAddress" value="http://10.12.7.101:10280/governanceserv/api/v1/reportsgeneration" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="SqlDataSourcesFreshnessCheckInterval" value="10" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="HBaseTake" value="100" xdt:Transform="InsertIfMissing" xdt:Locator="Match(key)" />
    <add key="SyncDsoDatabase" value="true" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="performProfileRestore" value="false" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="UseMongoGridFS" value="false" xdt:Transform="Remove" xdt:Locator="Match(key)" />
    <add key="ComparativeGroup" value="0" xdt:Transform="Remove" xdt:Locator="Match(key)" />
    <add key="CompanyType" value="0" xdt:Transform="Remove" xdt:Locator="Match(key)" />
    <add key="TemplateTypeEnum" value="0" xdt:Transform="Remove" xdt:Locator="Match(key)" />
    <add key ="CartePath" value="http://10.12.7.101:8081/kettle/executeJob/?job=D:/PDI/jobs/portfolio_analytics/fullPaDBSync.kjb" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="CarteMessage" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    <add key="CarteParameter" value="" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
  </appSettings>
  <system.net>
    <connectionManagement>
      <add address="https://cddbstage.azurehdinsight.net" maxconnection="128" xdt:Transform="InsertIfMissing" xdt:Locator="Match(address)" />
      <add address="https://sustainalytics.crm4.dynamics.com" maxconnection="128" xdt:Transform="InsertIfMissing" xdt:Locator="Match(address)" />
    </connectionManagement>
  </system.net>
</configuration>
